TipsMake

[QUIZ] Test your understanding of SQL - Part 1

SQL is a familiar term if you pay attention to the computer field. So what do you know about SQL?

★ [QUIZ] Test your understanding of SQL - Part 4
★ [QUIZ] Test your understanding of SQL - Part 3
  • Question 1: What does SQL mean?
    • Structured Question Language
    • Structured Query Language
    • Strong Question Language
  • Question 2: Which SQL statement is used to retrieve data from the database?
    • GET
    • OPEN
    • SELECT
    • EXTRACT
  • Question 3: Which SQL statement is used to update data in the database?
    • MODIFY
    • SAVE AS
    • SAVE
    • UPDATE
  • Question 4: Which SQL statement is used to delete data from the database?
    • REMOVE
    • DELETE
    • COLLAPSE
    • DROP
  • Question 5: Which SQL statement is used to add new data to the database?
    • ADD RECORD
    • ADD NEW
    • INSERT INTO
    • NEW INSERT
  • Question 6: In SQL, how to select a column named "FirstName" from the "Persons" table?
    • EXTRACT FirstName FROM Persons
    • SELECT FirstName FROM Persons
    • SELECT Persons.FirstName
  • Question 7: In SQL, how to select all columns from the "Persons" table?
    • SELECT [all] FROM Persons
    • SELECT * FROM Persons
    • SELECT * .Persons
    • SELECT Persons
  • Question 8: In SQL, how to select all records from the "Persons" table in which the value of "FirstName" column is "Peter"?
    • SELECT [all] FROM Persons WHERE FirstName = 'Peter'
    • SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter'
    • SELECT * FROM Persons WHERE FirstName <> 'Peter'
    • SELECT * FROM Persons WHERE FirstName = 'Peter'
  • Question 9: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column begins with "a"?
    • SELECT * FROM Persons WHERE FirstName LIKE '% a'
    • SELECT * FROM Persons WHERE FirstName LIKE 'a%'
    • SELECT * FROM Persons WHERE FirstName = '% a%'
    • SELECT * FROM Persons WHERE FirstName = 'a'
  • Question 10: The OR operator displays a record if the retrieved data only needs to satisfy one of the listed conditions. The AND operator displays the record if the retrieved data satisfies all the listed conditions.
    • It's correct
    • False
  • Question 11: In SQL, how to select all records from the "Persons" table in which the value of the "FirstName" column is "Peter" and "LastName" is "Jackson"?
    • SELECT * FROM Persons WHERE FirstName = 'Peter' AND LastName = 'Jackson'
    • SELECT * FROM Persons WHERE FirstName <> 'Peter' AND LastName <> 'Jackson'
    • SELECT FirstName = 'Peter', LastName = 'Jackson' FROM Persons
  • Question 12: In SQL, how to select all records from the "Persons" table in which "LastName" is sorted alphabetically and is in "Hansen" and "Pettersen" (including 2 values). this)
    • SELECT * FROM Persons WHERE LastName> 'Hansen' AND LastName <'Pettersen'
    • SELECT LastName> 'Hansen' AND LastName <'Pettersen' FROM Persons
    • SELECT * FROM Persons WHERE LastName BETWEEN 'Hansen' AND 'Pettersen'
  • Question 13: Which SQL statement is used to return unique values ​​in the table?
    • SELECT UNIQUE
    • SELECT DISTINCT
    • SELECT DIFFERENT
  • Question 14: Which SQL command is used to sort the result set?
    • SORT BY
    • SORT
    • ORDER
    • ORDER BY
  • Question 15: In SQL, how can I return all records from the "Persons" table sorted in descending order according to "FirstName"?
    • SELECT * FROM Persons SORT BY 'FirstName' DESC
    • SELECT * FROM Persons ORDER BY FirstName DESC
    • SELECT * FROM Persons SORT 'FirstName' DESC
    • SELECT * FROM Persons ORDER FirstName DESC

Discover more

learn sql database sql quizzes database test quiz sql check sql sql knowledge sql test sql exercises
Micah Soto

Share by

Micah Soto
Update 24 May 2019

You should read it